CREATE TABLE [dbo].[DnnProduct_Authentication]
(
[AuthenticationID] [int] NOT NULL IDENTITY(1, 1),
[PackageID] [int] NOT NULL CONSTRAINT [DF__DnnProduc__Packa__4F67C174] DEFAULT ((-1)),
[AuthenticationType] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsEnabled] [bit] NOT NULL CONSTRAINT [DF_DnnProduct_Authentication_IsEnabled] DEFAULT ((0)),
[SettingsControlSrc] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LoginControlSrc] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LogoffControlSrc] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreatedByUserID] [int] NULL,
[CreatedOnDate] [datetime] NULL,
[LastModifiedByUserID] [int] NULL,
[LastModifiedOnDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_Authentication] ADD CONSTRAINT [PK_DnnProduct_Authentication] PRIMARY KEY CLUSTERED  ([AuthenticationID]) WITH (FILLFACTOR=85) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_Authentication] WITH NOCHECK ADD CONSTRAINT [FK_DnnProduct_Authentication_DnnProduct_Packages] FOREIGN KEY ([PackageID]) REFERENCES [dbo].[DnnProduct_Packages] ([PackageID]) ON DELETE CASCADE ON UPDATE CASCADE
GO
